Pamela Wagner ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	19

About Me

About Me

About Me	I am a Sr. Project Manager in an IT department for a city hospital
How I Use Smartsheet	We use Smartsheet to help on our projects in the PMO but also use it to help out internal business clients to update their processes.

Analytics

168

Posts

290

Visits

9.0k

Points

Apr 6, 2020

Join Date

Nov 29, 2024

Last Active

Reactions

• Insightful 1

  1
• Vote Up 20

  20
• Awesome 5

  5

• Activity
• Discussions59
• Comments109

• Re: IF/AND Formula

  Pamela Wagner

  08/11/23
  Thanks @SteyJ ! I made one tweak: =IF([Invoice Received?]@row = 0, IF(AND([Renewal Date]@row >= TODAY(0), [Renewal Date]@row <= TODAY(+30)), "Red", "Yellow")) I don't need t…
  1 ·

• Re: Auto-move a row to another sheet when work complete?

  Pamela Wagner

  11/21/22
  @Cimafranca I believe you should be able to add a column for "Created Date" and that may pull in the date it was moved. You may try that.
  1 ·

• Dashboard - dropdowns to hide data

  Pamela Wagner

  10/14/22
  tldr: something where I can hide or display data in a dashboard without just putting in a link to the data. I am creating a dashboard that is very data heavy - think lots of charts, graphs, reports, …
  7 ·

• Why can't I attach a document?

  Pamela Wagner

  07/16/21
  I have a variety of luck with adding attachments to my sheets. One time it will work to attach a PDF the next time it just won't do it. I will try drag/drop into the attachment area other times I wil…
  1 ·

• Re: IF AND

  Pamela Wagner

  03/05/21
  I asked a colleague and it looks like we got it to work: =IF([% Complete]5 <= 0.6, "Red", IF([% Complete]5 < 1, "Yellow", IF([% Complete]5 = 1, "Green"))) I think …
  1 ·

Previous Next